﻿<%@ Control Language="C#" AutoEventWireup="true" CodeFile="CustomerSearch.ascx.cs" Inherits="webUserControl_CustomerSearch" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid" tagprefix="igtbl" %>
<%@ Register assembly="Infragistics2.WebUI.UltraWebGrid.ExcelExport.v8.1, Version=8.1.20081.1000, Culture=neutral, PublicKeyToken=7dd5c3163f2cd0cb" namespace="Infragistics.WebUI.UltraWebGrid.ExcelExport" tagprefix="igtblexp" %>
<style type="text/css">
    .style1
    {
        background-color: White;
    }
</style>
<div class="code">

    <asp:SqlDataSource ID="SqlDataSource1" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT * FROM [sysType]"></asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource4" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [ClassName] FROM [sysCatalog]">
    </asp:SqlDataSource>
    <asp:SqlDataSource ID="SqlDataSource5" runat="server" 
        ConnectionString="<%$ ConnectionStrings:LinFen %>" 
        SelectCommand="SELECT [ID], [DangCiName] FROM [sysDangCi]">
    </asp:SqlDataSource>
    <table style="width:100%; line-height:25px; font-size:12px;">
    <tr>
        <td style="text-align:left;">
            媒体类型：<asp:DropDownList ID="ddlisType" runat="server" 
        DataSourceID="SqlDataSource1" DataTextField="isType" DataValueField="ID">
    </asp:DropDownList>
            地市：<asp:DropDownList ID="ddlCityID" runat="server" AutoPostBack="True" 
        onselectedindexchanged="ddlCityID_SelectedIndexChanged">
    </asp:DropDownList>
    <asp:DropDownList ID="ddlDistrictID" runat="server">
    </asp:DropDownList>

            分类：<asp:DropDownList ID="ddlCatalog" runat="server" 
        DataSourceID="SqlDataSource4" DataTextField="ClassName" 
        DataValueField="ID" AppendDataBoundItems="True">
                <asp:ListItem Value="0">全部显示</asp:ListItem>
    </asp:DropDownList>
    档次：<asp:DropDownList ID="ddlDangCi" runat="server" 
        DataSourceID="SqlDataSource5" DataTextField="DangCiName" DataValueField="ID" 
                AppendDataBoundItems="True">
                <asp:ListItem Value="0">全部显示</asp:ListItem>
    </asp:DropDownList>
    &nbsp;编号：<asp:TextBox ID="tbID" runat="server" Width="40px"></asp:TextBox>
            点位名称：<asp:TextBox ID="tbSuppliername" runat="server"></asp:TextBox>
&nbsp;<asp:Button ID="btnSearch" runat="server" Text="查找" onclick="btnSearch_Click" />

<asp:Button ID="btnExcel" runat="server" onclick="btnExcel_Click" 
    Text="导出Excel" />
        &nbsp;<asp:Button ID="Button1" runat="server" onclick="Button1_Click" 
                Text="发布广告点位明细" />
        </td>
        <td style="text-align:left;">
            &nbsp;</td>
        <td style="text-align:left;">
            &nbsp;</td>
                <td>
                    &nbsp;</td>
    </tr>
    <tr>
        <td style="text-align:left;">
            <asp:CheckBoxList ID="chkDianWei" runat="server" RepeatDirection="Horizontal">
                <asp:ListItem Value="NumMale" Selected="True">男</asp:ListItem>
                <asp:ListItem Value="NumFemale" Selected="True">女</asp:ListItem>
                <asp:ListItem Value="NumHongGan" Selected="True">烘干机</asp:ListItem>
                <asp:ListItem Value="NumBaoJian" Selected="True">包间</asp:ListItem>
                <asp:ListItem Value="NumQiTa" Selected="True">其他（如选择消防点位，则此处显示消防点位）</asp:ListItem>
                <asp:ListItem Selected="True" Value="bak">备注</asp:ListItem>
            </asp:CheckBoxList>
            <asp:Label ID="lblSearchResult" runat="server" Text=""></asp:Label>
        </td>
        <td style="text-align:left;">
            &nbsp;</td>
        <td style="text-align:left;">
            &nbsp;</td>
                <td>
                    &nbsp;</td>
    </tr>
    </table>
</div>


    <asp:SqlDataSource ID="sqlDS" runat="server"></asp:SqlDataSource>
    <asp:GridView ID="GridView1" runat="server" CellPadding="4" 
        Font-Size="12px" ForeColor="#333333" GridLines="None" 
    AllowPaging="True" HorizontalAlign="Center" 
    onpageindexchanging="GridView1_PageIndexChanging" onsorting="GridView1_Sorting" 
    Width="100%">
        <FooterStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <RowStyle BackColor="#E3EAEB" Font-Size="14px" HorizontalAlign="Center" />
        <PagerStyle BackColor="#666666" ForeColor="White" HorizontalAlign="Center" />
        <SelectedRowStyle BackColor="#C5BBAF" Font-Bold="True" ForeColor="#333333" />
        <HeaderStyle BackColor="#1C5E55" Font-Bold="True" ForeColor="White" />
        <EditRowStyle BackColor="#7C6F57" />
        <AlternatingRowStyle BackColor="White" />
    </asp:GridView>
<igtbl:UltraWebGrid ID="UltraWebGrid1" runat="server" Height="200px" 
    Visible="False" Width="325px">
    <bands>
        <igtbl:UltraGridBand>
            <addnewrow view="NotSet" visible="NotSet">
            </addnewrow>
        </igtbl:UltraGridBand>
    </bands>
    <displaylayout allowcolsizingdefault="Free" allowcolumnmovingdefault="OnServer" 
        allowdeletedefault="Yes" allowsortingdefault="OnClient" 
        allowupdatedefault="Yes" bordercollapsedefault="Separate" 
        headerclickactiondefault="SortMulti" name="ctl00xUltraWebGrid1" 
        rowheightdefault="20px" rowselectorsdefault="No" 
        selecttyperowdefault="Extended" stationarymargins="Header" 
        stationarymarginsoutlookgroupby="True" tablelayout="Fixed" version="4.00" 
        viewtype="OutlookGroupBy">
        <framestyle backcolor="Window" bordercolor="InactiveCaption" 
            borderstyle="Solid" borderwidth="1px" font-names="Microsoft Sans Serif" 
            font-size="8.25pt" height="200px" width="325px">
        </framestyle>
        <pager minimumpagesfordisplay="2">
            <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
            </PagerStyle>
        </pager>
        <editcellstyledefault borderstyle="None" borderwidth="0px">
        </editcellstyledefault>
        <footerstyledefault backcolor="LightGray" borderstyle="Solid" borderwidth="1px">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
        </footerstyledefault>
        <headerstyledefault backcolor="LightGray" borderstyle="Solid" 
            horizontalalign="Left">
            <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                widthtop="1px" />
        </headerstyledefault>
        <rowstyledefault backcolor="Window" bordercolor="Silver" borderstyle="Solid" 
            borderwidth="1px" font-names="Microsoft Sans Serif" font-size="8.25pt">
            <padding left="3px" />
            <borderdetails colorleft="Window" colortop="Window" />
        </rowstyledefault>
        <groupbyrowstyledefault backcolor="Control" bordercolor="Window">
        </groupbyrowstyledefault>
        <groupbybox>
            <boxstyle backcolor="ActiveBorder" bordercolor="Window">
            </boxstyle>
        </groupbybox>
        <addnewbox hidden="False">
            <boxstyle backcolor="Window" bordercolor="InactiveCaption" borderstyle="Solid" 
                borderwidth="1px">
                <borderdetails colorleft="White" colortop="White" widthleft="1px" 
                    widthtop="1px" />
            </boxstyle>
        </addnewbox>
        <activationobject bordercolor="" borderwidth="">
        </activationobject>
        <filteroptionsdefault>
            <filterdropdownstyle backcolor="White" bordercolor="Silver" borderstyle="Solid" 
                borderwidth="1px" customrules="overflow:auto;" 
                font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px" height="300px" 
                width="200px">
                <padding left="2px" />
            </filterdropdownstyle>
            <filterhighlightrowstyle backcolor="#151C55" forecolor="White">
            </filterhighlightrowstyle>
            <filteroperanddropdownstyle backcolor="White" bordercolor="Silver" 
                borderstyle="Solid" borderwidth="1px" customrules="overflow:auto;" 
                font-names="Verdana,Arial,Helvetica,sans-serif" font-size="11px">
                <padding left="2px" />
            </filteroperanddropdownstyle>
        </filteroptionsdefault>
    </displaylayout>
</igtbl:UltraWebGrid>
    <igtbl:UltraWebGrid ID="UltraWebGrid2" runat="server" Height="200px" 
        Visible="False" Width="325px">
        <Bands>
            <igtbl:UltraGridBand>
                <AddNewRow View="NotSet" Visible="NotSet">
                </AddNewRow>
            </igtbl:UltraGridBand>
        </Bands>
        <DisplayLayout AllowColSizingDefault="Free" AllowColumnMovingDefault="OnServer" 
            AllowDeleteDefault="Yes" AllowSortingDefault="OnClient" 
            AllowUpdateDefault="Yes" BorderCollapseDefault="Separate" 
            HeaderClickActionDefault="SortMulti" Name="ctl00xUltraWebGrid2" 
            RowHeightDefault="20px" RowSelectorsDefault="No" 
            SelectTypeRowDefault="Extended" StationaryMargins="Header" 
            StationaryMarginsOutlookGroupBy="True" TableLayout="Fixed" Version="4.00" 
            ViewType="OutlookGroupBy">
            <FrameStyle BackColor="Window" BorderColor="InactiveCaption" 
                BorderStyle="Solid" BorderWidth="1px" Font-Names="Microsoft Sans Serif" 
                Font-Size="8.25pt" Height="200px" Width="325px">
            </FrameStyle>
            <Pager MinimumPagesForDisplay="2">
                <PagerStyle BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
                </PagerStyle>
            </Pager>
            <EditCellStyleDefault BorderStyle="None" BorderWidth="0px">
            </EditCellStyleDefault>
            <FooterStyleDefault BackColor="LightGray" BorderStyle="Solid" BorderWidth="1px">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
            </FooterStyleDefault>
            <HeaderStyleDefault BackColor="LightGray" BorderStyle="Solid" 
                HorizontalAlign="Left">
                <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                    WidthTop="1px" />
            </HeaderStyleDefault>
            <RowStyleDefault BackColor="Window" BorderColor="Silver" BorderStyle="Solid" 
                BorderWidth="1px" Font-Names="Microsoft Sans Serif" Font-Size="8.25pt">
                <Padding Left="3px" />
                <BorderDetails ColorLeft="Window" ColorTop="Window" />
            </RowStyleDefault>
            <GroupByRowStyleDefault BackColor="Control" BorderColor="Window">
            </GroupByRowStyleDefault>
            <GroupByBox>
                <BoxStyle BackColor="ActiveBorder" BorderColor="Window">
                </BoxStyle>
            </GroupByBox>
            <AddNewBox Hidden="False">
                <BoxStyle BackColor="Window" BorderColor="InactiveCaption" BorderStyle="Solid" 
                    BorderWidth="1px">
                    <BorderDetails ColorLeft="White" ColorTop="White" WidthLeft="1px" 
                        WidthTop="1px" />
                </BoxStyle>
            </AddNewBox>
            <ActivationObject BorderColor="" BorderWidth="">
            </ActivationObject>
            <FilterOptionsDefault>
                <FilterDropDownStyle BackColor="White" BorderColor="Silver" BorderStyle="Solid" 
                    BorderWidth="1px" CustomRules="overflow:auto;" 
                    Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px" Height="300px" 
                    Width="200px">
                    <Padding Left="2px" />
                </FilterDropDownStyle>
                <FilterHighlightRowStyle BackColor="#151C55" ForeColor="White">
                </FilterHighlightRowStyle>
                <FilterOperandDropDownStyle BackColor="White" BorderColor="Silver" 
                    BorderStyle="Solid" BorderWidth="1px" CustomRules="overflow:auto;" 
                    Font-Names="Verdana,Arial,Helvetica,sans-serif" Font-Size="11px">
                    <Padding Left="2px" />
                </FilterOperandDropDownStyle>
            </FilterOptionsDefault>
        </DisplayLayout>
    </igtbl:UltraWebGrid>
    <asp:Panel ID="Panel1" runat="server"> 
    <table cellspacing="1" 
    style="width:100%; line-height:25px; text-align:center; background-color:blue; font-size:12px; color:Black;">
     
    <tr>
        <td class="style1">
        </td>
        <td class="style1">
            男</td>
        <td class="style1">
            女</td>
        <td class="style1">
            烘干器</td>
        <td class="style1">
            包间</td>
        <td class="style1">
            其他</td>
        <td class="style1">
            总计</td>
    </tr>
    <asp:Panel ID="Panel2" runat="server">
     <tr>
        <td class="style1">
            已发布</td>
        <td class="style1">
            <asp:Label ID="lblMale1" runat="server" Text=""></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblFemale1" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblHongGan1" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblBaoJian1" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblQiTa1" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblTotal1" runat="server"></asp:Label>
        </td>
    </tr>
    
    
       
        </asp:Panel>
  <tr>
        <td class="style1">
            招商空</td>
        <td class="style1">
            <asp:Label ID="lblMale2" runat="server" Text=""></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblFemale2" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblHongGan2" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblBaoJian2" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblQiTa2" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblTotal2" runat="server"></asp:Label>
        </td>
    </tr>
        <asp:Panel ID="Panel3" runat="server">
    
    <tr>
        <td class="style1">
            合计</td>
        <td class="style1">
            <asp:Label ID="lblMale3" runat="server" Text=""></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblFemale3" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblHongGan3" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblBaoJian3" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblQiTa3" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblTotal3" runat="server"></asp:Label>
        </td>
    </tr>
    <tr>
        <td class="style1">
            空租率%</td>
        <td class="style1">
            <asp:Label ID="lblMale4" runat="server" Text=""></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblFemale4" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblHongGan4" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblBaoJian4" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblQiTa4" runat="server"></asp:Label>
        </td>
        <td class="style1">
            <asp:Label ID="lblTotal4" runat="server"></asp:Label>
        </td>
    </tr>
        </asp:Panel>
</table>
    </asp:Panel>
<igtblexp:UltraWebGridExcelExporter ID="UltraWebGridExcelExporter1" 
    runat="server">
</igtblexp:UltraWebGridExcelExporter>




